﻿CREATE TABLE [dbo].[ParteneriConturiBancare] (
    [IDContBancar] INT          IDENTITY (1, 1) NOT NULL,
    [IDPartener]   BIGINT       NOT NULL,
    [ContBancar]   VARCHAR (50) NOT NULL,
    [IDBanca]      SMALLINT     NOT NULL,
    CONSTRAINT [PK_ParteneriConturiBancare] PRIMARY KEY CLUSTERED ([IDContBancar] ASC),
    CONSTRAINT [FK_ParteneriConturiBancare_Banci] FOREIGN KEY ([IDBanca]) REFERENCES [dbo].[Banci] ([IdBanca]),
    CONSTRAINT [FK_ParteneriConturiBancare_Parteneri] FOREIGN KEY ([IDPartener]) REFERENCES [dbo].[Parteneri] ([IDPartener])
);

